﻿--****************  İller
SET IDENTITY_INSERT ESL.TOWN ON
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (01,1,'ADANA');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (02,1,'ADIYAMAN');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (03,1,'AFYON');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (04,1,'AĞRI');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (05,1,'AMASYA');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (06,1,'ANKARA');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (07,1,'ANTALYA');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (08,1,'ARTVİN');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (09,1,'AYDIN');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (10,1,'BALIKESİR');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (11,1,'BİLECİK');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (12,1,'BİNGÖL');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (13,1,'BİTLİS');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (14,1,'BOLU');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (15,1,'BURDUR');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (16,1,'BURSA');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (17,1,'ÇANAKKALE');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (18,1,'ÇANKIRI');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (19,1,'ÇORUM');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (20,1,'DENİZLİ');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (21,1,'DİYARBAKIR');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (22,1,'EDİRNE');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (23,1,'ELAZIĞ');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (24,1,'ERZİNCAN');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (25,1,'ERZURUM');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (26,1,'ESKİŞEHİR');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (27,1,'GAZİANTEP');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (28,1,'GİRESUN');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (29,1,'GÜMÜŞHANE');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (30,1,'HAKKARİ');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (31,1,'HATAY');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (32,1,'ISPARTA');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (33,1,'İÇEL');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (34,1,'İSTANBUL');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (35,1,'İZMİR');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (36,1,'KARS');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (37,1,'KASTAMONU');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (38,1,'KAYSERİ');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (39,1,'KIRKLARELİ');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (40,1,'KIRŞEHİR');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (41,1,'KOCAELİ');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (42,1,'KONYA');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (43,1,'KÜTAHYA');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (44,1,'MALATYA');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (45,1,'MANİSA');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (46,1,'KAHRAMANMARAŞ');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (47,1,'MARDİN');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (48,1,'MUĞLA');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (49,1,'MUŞ');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (50,1,'NEVŞEHİR');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (51,1,'NİĞDE');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (52,1,'ORDU');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (53,1,'RİZE');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (54,1,'SAKARYA');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (55,1,'SAMSUN');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (56,1,'SİİRT');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (57,1,'SİNOP');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (58,1,'SİVAS');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (59,1,'TEKİRDAĞ');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (60,1,'TOKAT');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (61,1,'TRABZON');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (62,1,'TUNCELİ');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (63,1,'ŞANLIURFA');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (64,1,'UŞAK');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (65,1,'VAN');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (66,1,'YOZGAT');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (67,1,'ZONGULDAK');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (68,1,'AKSARAY');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (69,1,'BAYBURT');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (70,1,'KARAMAN');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (71,1,'KIRIKKALE');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (72,1,'BATMAN');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (73,1,'ŞIRNAK');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (74,1,'BARTIN');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (75,1,'ARDAHAN');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (76,1,'IĞDIR');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (77,1,'YALOVA');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (78,1,'KARABÜK');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (79,1,'KİLİS');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (80,1,'OSMANİYE');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (81,1,'DÜZCE');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (101,2,'GAZİMAĞUSA');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (102,2,'GİRNE');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (103,2,'GÜZELYURT');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (104,2,'İSKELE');
INSERT INTO ESL.TOWN (Id,CountryId,Name) VALUES (105,2,'LEFKOŞA');
SET IDENTITY_INSERT ESL.TOWN OFF
--****************  İller



--****************  İlçeler
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,1,'ALADAĞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,1,'CEYHAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,1,'ÇUKUROVA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,1,'FEKE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,1,'İMAMOĞLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,1,'KARAİSALI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,1,'KARATAŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,1,'KOZAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,1,'POZANTI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,1,'SAİMBEYLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,1,'SARIÇAM');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,1,'SEYHAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,1,'TUFANBEYLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,1,'YUMURTALIK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,1,'YÜREĞİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,2,'ADIYAMAN MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,2,'BESNİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,2,'ÇELİKHAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,2,'GERGER');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,2,'GÖLBAŞI/ADIYAMAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,2,'KAHTA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,2,'SAMSAT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,2,'SİNCİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,2,'TUT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,3,'AFYONKARAHİSAR MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,3,'BAŞMAKÇI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,3,'BAYAT/AFYON');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,3,'BOLVADİN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,3,'ÇAY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,3,'ÇOBANLAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,3,'DAZKIRI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,3,'DİNAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,3,'EMİRDAĞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,3,'EVCİLER');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,3,'HOCALAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,3,'İHSANİYE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,3,'İSCEHİSAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,3,'KIZILÖREN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,3,'SANDIKLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,3,'SİNANPAŞA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,3,'SULTANDAĞI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,3,'ŞUHUT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,4,'AĞRI MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,4,'DİYADİN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,4,'DOĞUBAYAZIT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,4,'ELEŞKİRT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,4,'HAMUR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,4,'PATNOS');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,4,'TAŞLIÇAY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,4,'TUTAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,5,'AMASYA MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,5,'GÖYNÜCEK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,5,'GÜMÜŞHACIKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,5,'HAMAMÖZÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,5,'MERZİFON');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,5,'SULUOVA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,5,'TAŞOVA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'AKYURT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'ALTINDAĞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'AYAŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'BALA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'BEYPAZARI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'ÇAMLIDERE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'ÇANKAYA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'ÇUBUK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'ELMADAĞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'ETİMESGUT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'EVREN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'GÖLBAŞI/ANKARA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'GÜDÜL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'HAYMANA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'KALECİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'KAZAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'KEÇİÖREN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'KIZILCAHAMAM');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'MAMAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'NALLIHAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'POLATLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'PURSAKLAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'SİNCAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'ŞEREFLİKOÇHİSAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,6,'YENİMAHALLE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'AKSEKİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'AKSU / ANTALYA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'ALANYA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'ANTALYA MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'DEMRE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'DÖŞEMEALTI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'ELMALI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'FİNİKE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'GAZİPAŞA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'GÜNDOĞMUŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'İBRADI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'KAŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'KEMER/ANTALYA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'KEPEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'KONYAALTI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'KORKUTELİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'KUMLUCA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'MANAVGAT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'MURATPAŞA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,7,'SERİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,8,'ARDANUÇ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,8,'ARHAVİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,8,'ARTVİN MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,8,'BORÇKA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,8,'HOPA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,8,'MURGUL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,8,'ŞAVŞAT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,8,'YUSUFELİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,9,'AYDIN MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,9,'BOZDOĞAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,9,'BUHARKENT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,9,'ÇİNE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,9,'DİDİM (YENİHİSAR)');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,9,'GERMENCİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,9,'İNCİRLİOVA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,9,'KARACASU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,9,'KARPUZLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,9,'KOÇARLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,9,'KÖŞK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,9,'KUŞADASI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,9,'KUYUCAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,9,'NAZİLLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,9,'SÖKE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,9,'SULTANHİSAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,9,'YENİPAZAR/AYDIN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'AYVALIK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'BALIKESİR MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'BALYA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'BANDIRMA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'BİGADİÇ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'BURHANİYE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'DURSUNBEY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'EDREMİT/BALIKESİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'ERDEK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'GÖMEÇ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'GÖNEN/BALIKESİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'HAVRAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'İVRİNDİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'KEPSUT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'MANYAS');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'MARMARA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'SAVAŞTEPE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'SINDIRGI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,10,'SUSURLUK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,11,'BİLECİK MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,11,'BOZÜYÜK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,11,'GÖLPAZARI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,11,'İNHİSAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,11,'OSMANELİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,11,'PAZARYERİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,11,'SÖĞÜT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,11,'YENİPAZAR/BİLECİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,12,'ADAKLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,12,'BİNGÖL MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,12,'GENÇ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,12,'KARLIOVA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,12,'KİĞI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,12,'SOLHAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,12,'YAYLADERE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,12,'YEDİSU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,13,'ADİLCEVAZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,13,'AHLAT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,13,'BİTLİS MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,13,'GÜROYMAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,13,'HİZAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,13,'MUTKİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,13,'TATVAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,14,'BOLU MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,14,'DÖRTDİVAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,14,'GEREDE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,14,'GÖYNÜK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,14,'KIBRISCIK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,14,'MENGEN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,14,'MUDURNU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,14,'SEBEN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,14,'YENİÇAĞA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,15,'AĞLASUN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,15,'ALTINYAYLA/BURDUR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,15,'BUCAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,15,'BURDUR MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,15,'ÇAVDIR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,15,'ÇELTİKÇİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,15,'GÖLHİSAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,15,'KARAMANLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,15,'KEMER/BURDUR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,15,'TEFENNİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,15,'YEŞİLOVA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,16,'BÜYÜKORHAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,16,'GEMLİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,16,'GÜRSU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,16,'HARMANCIK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,16,'İNEGÖL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,16,'İZNİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,16,'KARACABEY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,16,'KELES');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,16,'KESTEL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,16,'MUDANYA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,16,'MUSTAFA K.PAŞA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,16,'NİLÜFER');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,16,'ORHANELİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,16,'ORHANGAZİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,16,'OSMANGAZİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,16,'YENİŞEHİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,16,'YILDIRIM');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,17,'AYVACIK/ÇANAKKALE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,17,'BAYRAMİÇ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,17,'BİGA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,17,'BOZCAADA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,17,'ÇAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,17,'ÇANAKKALE MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,17,'ECEABAT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,17,'EZİNE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,17,'GELİBOLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,17,'GÖKÇEADA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,17,'LAPSEKİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,17,'YENİCE/ÇANAKKALE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,18,'ATKARACALAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,18,'BAYRAMÖREN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,18,'ÇANKIRI MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,18,'ÇERKEŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,18,'ELDİVAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,18,'ILGAZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,18,'KIZILIRMAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,18,'KORGUN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,18,'KURŞUNLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,18,'ORTA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,18,'ŞABANÖZÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,18,'YAPRAKLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,19,'ALACA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,19,'BAYAT/ÇORUM');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,19,'BOĞAZKALE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,19,'ÇORUM MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,19,'DODURGA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,19,'İSKİLİP');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,19,'KARGI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,19,'LAÇİN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,19,'MECİTÖZÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,19,'OĞUZLAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,19,'ORTAKÖY/ÇORUM');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,19,'OSMANCIK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,19,'SUNGURLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,19,'UĞURLUDAĞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'ACIPAYAM');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'AKKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'BABADAĞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'BAKLAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'BEKİLLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'BEYAĞAÇ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'BOZKURT/DENİZLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'BULDAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'ÇAL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'ÇAMELİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'ÇARDAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'ÇİVRİL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'DENİZLİ MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'GÜNEY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'HONAZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'KALE/DENİZLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'SARAYKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'SERİNHİSAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,20,'TAVAS');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,21,'BAĞLAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,21,'BİSMİL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,21,'ÇERMİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,21,'ÇINAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,21,'ÇÜNGÜŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,21,'DİCLE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,21,'DİYARBAKIR MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,21,'EĞİL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,21,'ERGANİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,21,'HANİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,21,'HAZRO');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,21,'KAYAPINAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,21,'KOCAKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,21,'KULP');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,21,'LİCE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,21,'SİLVAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,21,'SUR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,21,'YENİŞEHİR / DİYARBAKIR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,22,'EDİRNE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,22,'ENEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,22,'HAVSA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,22,'İPSALA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,22,'KEŞAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,22,'LALAPAŞA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,22,'MERİÇ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,22,'SÜLOĞLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,22,'UZUNKÖPRÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,23,'AĞIN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,23,'ALACAKAYA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,23,'ARICAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,23,'BASKİL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,23,'ELAZIĞ MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,23,'KARAKOÇAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,23,'KEBAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,23,'KOVANCILAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,23,'MADEN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,23,'PALU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,23,'SİVRİCE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,24,'ÇAYIRLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,24,'ERZİNCAN MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,24,'İLİÇ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,24,'KEMAH');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,24,'KEMALİYE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,24,'OTLUKBELİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,24,'REFAHİYE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,24,'TERCAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,24,'ÜZÜMLÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'AŞKALE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'ÇAT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'ERZURUM MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'HINIS');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'HORASAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'ILICA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'İSPİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'KARAÇOBAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'KARAYAZI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'KÖPRÜKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'NARMAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'OLTU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'OLUR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'PALANDÖKEN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'PASİNLER');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'PAZARYOLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'ŞENKAYA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'TEKMAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'TORTUM');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'UZUNDERE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,25,'YAKUTİYE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,26,'ALPU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,26,'BEYLİKOVA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,26,'ÇİFTELER');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,26,'ESKİŞEHİR MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,26,'GÜNYÜZÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,26,'HAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,26,'İNÖNÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,26,'MAHMUDİYE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,26,'MİHALGAZİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,26,'MİHALIÇÇIK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,26,'ODUNPAZARI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,26,'SARICAKAYA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,26,'SEYİTGAZİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,26,'SİVRİHİSAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,26,'TEPEBAŞI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,27,'ARABAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,27,'İSLAHİYE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,27,'KARKAMIŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,27,'NİZİP');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,27,'NURDAĞI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,27,'OĞUZELİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,27,'ŞAHİNBEY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,27,'ŞEHİTKAMİL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,27,'YAVUZELİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,28,'ALUCRA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,28,'BULANCAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,28,'ÇAMOLUK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,28,'ÇANAKÇI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,28,'DERELİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,28,'DOĞANKENT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,28,'ESPİYE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,28,'EYNESİL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,28,'GİRESUN MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,28,'GÖRELE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,28,'GÜCE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,28,'KEŞAP');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,28,'PİRAZİZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,28,'ŞEBİNKARAHİSAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,28,'TİREBOLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,28,'YAĞLIDERE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,29,'GÜMÜŞHANE MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,29,'KELKİT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,29,'KÖSE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,29,'KÜRTÜN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,29,'ŞİRAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,29,'TORUL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,30,'ÇUKURCA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,30,'HAKKARİ MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,30,'ŞEMDİNLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,30,'YÜKSEKOVA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,31,'ALTINÖZÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,31,'BELEN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,31,'DÖRTYOL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,31,'ERZİN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,31,'HASSA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,31,'HATAY MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,31,'İSKENDERUN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,31,'KIRIKHAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,31,'KUMLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,31,'REYHANLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,31,'SAMANDAĞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,31,'YAYLADAĞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,32,'AKSU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,32,'ATABEY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,32,'EĞİRDİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,32,'GELENDOST');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,32,'GÖNEN/ISPARTA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,32,'ISPARTA MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,32,'KEÇİBORLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,32,'SENİRKENT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,32,'SÜTÇÜLER');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,32,'ŞARKİKARAAĞAÇ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,32,'ULUBORLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,32,'YALVAÇ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,32,'YENİŞARBADEMLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,33,'AKDENİZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,33,'ANAMUR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,33,'AYDINCIK/MERSİN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,33,'BOZYAZI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,33,'ÇAMLIYAYLA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,33,'ERDEMLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,33,'GÜLNAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,33,'MERSİN MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,33,'MEZİTLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,33,'MUT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,33,'SİLİFKE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,33,'TARSUS');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,33,'TOROSLAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,33,'YENİŞEHİR / MERSİN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'ADALAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'ARNAVUTKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'ATAŞEHİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'AVCILAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'BAĞCILAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'BAHÇELİEVLER');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'BAKIRKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'BAŞAKŞEHİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'BAYRAMPAŞA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'BEŞİKTAŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'BEYKOZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'BEYLİKDÜZÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'BEYOĞLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'BÜYÜKÇEKMECE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'ÇATALCA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'ÇEKMEKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'EMİNÖNÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'ESENLER');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'ESENYURT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'EYÜP');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'FATİH');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'GAZİOSMANPAŞA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'GÜNGÖREN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'KADIKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'KAĞITHANE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'KARTAL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'KÜÇÜKÇEKMECE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'MALTEPE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'PENDİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'SANCAKTEPE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'SARIYER');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'SİLİVRİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'SULTANBEYLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'SULTANGAZİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'ŞİLE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'ŞİŞLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'TUZLA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'ÜMRANİYE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'ÜSKÜDAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,34,'ZEYTİNBURNU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'ALİAĞA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'BALÇOVA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'BAYINDIR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'BAYRAKLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'BERGAMA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'BEYDAĞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'BORNOVA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'BUCA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'ÇEŞME');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'ÇİĞLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'DİKİLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'FOÇA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'GAZİEMİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'GÜZELBAHÇE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'KARABAĞLAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'KARABURUN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'KARŞIYAKA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'KEMALPAŞA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'KINIK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'KİRAZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'KONAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'MENDERES');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'MENEMEN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'NARLIDERE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'ÖDEMİŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'SEFERİHİSAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'SELÇUK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'TİRE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'TORBALI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,35,'URLA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,36,'AKYAKA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,36,'ARPAÇAY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,36,'DİGOR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,36,'KAĞIZMAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,36,'KARS MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,36,'SARIKAMIŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,36,'SELİM');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,36,'SUSUZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'ABANA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'AĞLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'ARAÇ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'AZDAVAY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'BOZKURT/KASTAMONU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'CİDE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'ÇATALZEYTİN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'DADAY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'DEVREKANİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'DOĞANYURT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'HANÖNÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'İHSANGAZİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'İNEBOLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'KASTAMONU MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'KÜRE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'PINARBAŞI/KASTAMONU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'SEYDİLER');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'ŞENPAZAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'TAŞKÖPRÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,37,'TOSYA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,38,'AKKIŞLA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,38,'BÜNYAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,38,'DEVELİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,38,'FELAHİYE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,38,'HACILAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,38,'İNCESU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,38,'KOCASİNAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,38,'MELİKGAZİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,38,'ÖZVATAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,38,'PINARBAŞI/KAYSERİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,38,'SARIOĞLAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,38,'SARIZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,38,'TALAS');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,38,'TOMARZA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,38,'YAHYALI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,38,'YEŞİLHİSAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,39,'BABAESKİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,39,'DEMİRKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,39,'KIRKLARELİ MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,39,'KOFÇAZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,39,'LÜLEBURGAZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,39,'PEHLİVANKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,39,'PINARHİSAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,39,'VİZE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,40,'AKÇAKENT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,40,'AKPINAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,40,'BOZTEPE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,40,'ÇİÇEKDAĞI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,40,'KAMAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,40,'KIRŞEHİR MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,40,'MUCUR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,41,'BAŞİSKELE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,41,'ÇAYIROVA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,41,'DARICA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,41,'DERİNCE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,41,'DİLOVASI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,41,'GEBZE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,41,'GÖLCÜK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,41,'İZMİT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,41,'KANDIRA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,41,'KARAMÜRSEL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,41,'KARTEPE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,41,'KOCAELİ MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,41,'KÖRFEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'AHIRLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'AKÖREN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'AKŞEHİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'ALTINEKİN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'BEYŞEHİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'BOZKIR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'CİHANBEYLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'ÇELTİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'ÇUMRA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'DERBENT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'DEREBUCAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'DOĞANHİSAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'EMİRGAZİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'EREĞLİ/KONYA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'GÜNEYSINIR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'HADİM');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'HALKAPINAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'HÜYÜK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'ILGIN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'KADINHANI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'KARAPINAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'KARATAY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'KULU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'MERAM');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'SARAYÖNÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'SELÇUKLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'SEYDİŞEHİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'TAŞKENT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'TUZLUKÇU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'YALIHÜYÜK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,42,'YUNAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,43,'ALTINTAŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,43,'ASLANAPA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,43,'ÇAVDARHİSAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,43,'DOMANİÇ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,43,'DUMLUPINAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,43,'EMET');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,43,'GEDİZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,43,'HİSARCIK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,43,'KÜTAHYA MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,43,'PAZARLAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,43,'SİMAV');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,43,'ŞAPHANE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,43,'TAVŞANLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,44,'AKÇADAĞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,44,'ARAPGİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,44,'ARGUVAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,44,'BATTALGAZİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,44,'DARENDE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,44,'DOĞANŞEHİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,44,'DOĞANYOL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,44,'HEKİMHAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,44,'KALE/MALATYA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,44,'KULUNCAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,44,'MALATYA MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,44,'PÜTÜRGE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,44,'YAZIHAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,44,'YEŞİLYURT/MALATYA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,45,'AHMETLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,45,'AKHİSAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,45,'ALAŞEHİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,45,'DEMİRCİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,45,'GÖLMARMARA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,45,'GÖRDES');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,45,'KIRKAĞAÇ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,45,'KÖPRÜBAŞI/MANİSA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,45,'KULA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,45,'MANİSA MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,45,'SALİHLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,45,'SARIGÖL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,45,'SARUHANLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,45,'SELENDİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,45,'SOMA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,45,'TURGUTLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,46,'AFŞİN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,46,'ANDIRIN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,46,'ÇAĞLIYANCERİT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,46,'EKİNÖZÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,46,'ELBİSTAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,46,'GÖKSUN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,46,'KAHRAMANMARAŞ MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,46,'NURHAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,46,'PAZARCIK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,46,'TÜRKOĞLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,47,'DARGEÇİT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,47,'DERİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,47,'KIZILTEPE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,47,'MARDİN MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,47,'MAZIDAĞI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,47,'MİDYAT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,47,'NUSAYBİN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,47,'ÖMERLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,47,'SAVUR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,47,'YEŞİLLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,48,'BODRUM');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,48,'DALAMAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,48,'DATÇA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,48,'FETHİYE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,48,'KAVAKLIDERE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,48,'KÖYCEĞİZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,48,'MARMARİS');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,48,'MİLAS');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,48,'MUĞLA MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,48,'ORTACA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,48,'ULA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,48,'YATAĞAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,49,'BULANIK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,49,'HASKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,49,'KORKUT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,49,'MALAZGİRT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,49,'MUŞ MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,49,'VARTO');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,50,'ACIGÖL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,50,'AVANOS');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,50,'DERİNKUYU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,50,'GÜLŞEHİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,50,'HACIBEKTAŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,50,'KOZAKLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,50,'NEVŞEHİR MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,50,'ÜRGÜP');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,51,'ALTUNHİSAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,51,'BOR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,51,'ÇAMARDI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,51,'ÇİFTLİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,51,'NİĞDE MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,51,'ULUKIŞLA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'AKKUŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'AYBASTI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'ÇAMAŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'ÇATALPINAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'ÇAYBAŞI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'FATSA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'GÖLKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'GÜLYALI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'GÜRGENTEPE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'İKİZCE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'KABADÜZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'KABATAŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'KORGAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'KUMRU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'MESUDİYE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'ORDU MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'PERŞEMBE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'ULUBEY/ORDU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,52,'ÜNYE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,53,'ARDEŞEN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,53,'ÇAMLIHEMŞİN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,53,'ÇAYELİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,53,'DEREPAZARI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,53,'FINDIKLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,53,'GÜNEYSU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,53,'HEMŞİN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,53,'İKİZDERE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,53,'İYİDERE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,53,'KALKANDERE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,53,'PAZAR/RİZE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,53,'RİZE MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,54,'ADAPAZARI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,54,'AKYAZI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,54,'ARİFİYE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,54,'ERENLER');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,54,'FERİZLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,54,'GEYVE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,54,'HENDEK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,54,'KARAPÜRÇEK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,54,'KARASU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,54,'KAYNARCA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,54,'KOCAALİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,54,'PAMUKOVA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,54,'SAKARYA MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,54,'SAPANCA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,54,'SERDİVAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,54,'SÖĞÜTLÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,54,'TARAKLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,55,'ALAÇAM');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,55,'ASARCIK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,55,'ATAKUM');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,55,'AYVACIK/SAMSUN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,55,'BAFRA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,55,'CANİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,55,'ÇARŞAMBA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,55,'HAVZA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,55,'İLKADIM');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,55,'KAVAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,55,'LADİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,55,'ONDOKUZMAYIS');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,55,'SALIPAZARI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,55,'SAMSUN MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,55,'TEKKEKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,55,'TERME');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,55,'VEZİRKÖPRÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,55,'YAKAKENT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,56,'AYDINLAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,56,'BAYKAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,56,'ERUH');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,56,'KURTALAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,56,'PERVARİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,56,'SİİRT MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,56,'ŞİRVAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,57,'AYANCIK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,57,'BOYABAT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,57,'DİKMEN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,57,'DURAĞAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,57,'ERFELEK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,57,'GERZE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,57,'SARAYDÜZÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,57,'SİNOP MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,57,'TÜRKELİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,58,'AKINCILAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,58,'ALTINYAYLA/SİVAS');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,58,'DİVRİĞİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,58,'DOĞANŞAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,58,'GEMEREK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,58,'GÖLOVA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,58,'GÜRÜN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,58,'HAFİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,58,'İMRANLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,58,'KANGAL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,58,'KOYULHİSAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,58,'SİVAS MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,58,'SUŞEHRİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,58,'ŞARKIŞLA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,58,'ULAŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,58,'YILDIZELİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,58,'ZARA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,59,'ÇERKEZKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,59,'ÇORLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,59,'HAYRABOLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,59,'MALKARA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,59,'MARMARAEREĞLİSİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,59,'MURATLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,59,'SARAY/TEKİRDAĞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,59,'ŞARKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,59,'TEKİRDAĞ MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,60,'ALMUS');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,60,'ARTOVA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,60,'BAŞÇİFTLİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,60,'ERBAA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,60,'NİKSAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,60,'PAZAR/TOKAT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,60,'REŞADİYE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,60,'SULUSARAY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,60,'TOKAT MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,60,'TURHAL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,60,'YEŞİLYURT/TOKAT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,60,'ZİLE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,61,'AKÇAABAT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,61,'ARAKLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,61,'ARSİN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,61,'BEŞİKDÜZÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,61,'ÇARŞIBAŞI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,61,'ÇAYKARA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,61,'DERNEKPAZARI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,61,'DÜZKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,61,'HAYRAT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,61,'KÖPRÜBAŞI/TRABZON');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,61,'MAÇKA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,61,'OF');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,61,'SÜRMENE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,61,'ŞALPAZARI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,61,'TONYA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,61,'TRABZON MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,61,'VAKFIKEBİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,61,'YOMRA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,62,'ÇEMİŞGEZEK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,62,'HOZAT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,62,'MAZGİRT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,62,'NAZIMİYE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,62,'OVACIK/TUNCELİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,62,'PERTEK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,62,'PÜLÜMÜR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,62,'TUNCELİ MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,63,'AKÇAKALE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,63,'BİRECİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,63,'BOZOVA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,63,'CEYLANPINAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,63,'HALFETİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,63,'HARRAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,63,'HİLVAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,63,'SİVEREK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,63,'SURUÇ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,63,'ŞANLIURFA MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,63,'VİRANŞEHİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,64,'BANAZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,64,'EŞME');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,64,'KARAHALLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,64,'SİVASLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,64,'ULUBEY/UŞAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,64,'UŞAK MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,65,'BAHÇESARAY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,65,'BAŞKALE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,65,'ÇALDIRAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,65,'ÇATAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,65,'EDREMİT/VAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,65,'ERCİŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,65,'GEVAŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,65,'GÜRPINAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,65,'MURADİYE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,65,'ÖZALP');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,65,'SARAY/VAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,65,'VAN MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,66,'AKDAĞMADENİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,66,'AYDINCIK/YOZGAT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,66,'BOĞAZLIYAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,66,'ÇANDIR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,66,'ÇAYIRALAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,66,'ÇEKEREK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,66,'KADIŞEHRİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,66,'SARAYKENT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,66,'SARIKAYA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,66,'SORGUN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,66,'ŞEFAATLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,66,'YENİFAKILI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,66,'YERKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,66,'YOZGAT MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,67,'ALAPLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,67,'ÇAYCUMA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,67,'DEVREK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,67,'EREĞLİ/ZONGULDAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,67,'GÖKÇEBEY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,67,'ZONGULDAK MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,68,'AĞAÇÖREN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,68,'AKSARAY MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,68,'ESKİL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,68,'GÜLAĞAÇ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,68,'GÜZELYURT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,68,'ORTAKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,68,'SARIYAHŞİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,69,'AYDINTEPE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,69,'BAYBURT MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,69,'DEMİRÖZÜ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,70,'AYRANCI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,70,'BAŞYAYLA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,70,'ERMENEK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,70,'KARAMAN MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,70,'KAZIMKARABEKİR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,70,'SARIVELİLER');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,71,'BAHŞİLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,71,'BALIŞEYH');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,71,'ÇELEBİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,71,'DELİCE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,71,'KARAKEÇİLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,71,'KESKİN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,71,'KIRIKKALE MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,71,'SULAKYURT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,71,'YAHŞİHAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,72,'BATMAN MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,72,'BEŞİRİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,72,'GERCÜŞ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,72,'HASANKEYF');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,72,'KOZLUK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,72,'SASON');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,73,'BEYTÜŞŞEBAP');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,73,'CİZRE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,73,'GÜÇLÜKONAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,73,'İDİL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,73,'SİLOPİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,73,'ŞIRNAK MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,73,'ULUDERE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,74,'AMASRA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,74,'BARTIN MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,74,'KURUCAŞİLE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,74,'ULUS');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,75,'ARDAHAN MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,75,'ÇILDIR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,75,'DAMAL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,75,'GÖLE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,75,'HANAK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,75,'POSOF');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,76,'ARALIK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,76,'IĞDIR MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,76,'KARAKOYUNLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,76,'TUZLUCA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,77,'ALTINOVA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,77,'ARMUTLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,77,'ÇINARCIK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,77,'ÇİFTLİKKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,77,'TERMAL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,77,'YALOVA MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,78,'EFLANİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,78,'ESKİPAZAR');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,78,'KARABÜK MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,78,'OVACIK/KARABÜK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,78,'SAFRANBOLU');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,78,'YENİCE/KARABÜK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,79,'ELBEYLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,79,'KİLİS MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,79,'MUSABEYLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,79,'POLATELİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,80,'BAHÇE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,80,'DÜZİÇİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,80,'HASANBEYLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,80,'KADİRLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,80,'OSMANİYE MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,80,'SUMBAS');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,80,'TOPRAKKALE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,81,'AKÇAKOCA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,81,'CUMAYERİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,81,'ÇİLİMLİ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,81,'DÜZCE MERKEZ');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,81,'GÖLYAKA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,81,'GÜMÜŞOVA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,81,'KAYNAŞLI');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (1,81,'YIĞILCA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (2,101,'AKDOĞAN');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (2,101,'GAZİMAĞUSA');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (2,101,'GEÇİTKALE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (2,102,'GİRNE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (2,102,'ÇAMLIBEL');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (2,103,'GÜZELYURT');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (2,103,'LEFKE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (2,104,'MEHMETÇİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (2,104,'İSKELE');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (2,104,'YENİ ERENKÖY');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (2,105,'DEĞİRMENLİK');
INSERT INTO ESL.TOWN (CountryId,ParentId,Name) VALUES (2,105,'LEFKOŞA');
--****************  İlçeler